package com.example.demo.mapper;

import com.example.demo.entity.Info;
import org.apache.ibatis.annotations.Insert;
import org.apache.ibatis.annotations.Select;

import java.sql.Timestamp;
import java.util.Date;
import java.util.List;
//用户信息模糊查询和时间区间查询
public interface InforMapper<Infor> {
    @Select("select id,names,password,email,createtime from infor where createtime between #{starttime}and #{endtime};")
    public List<Infor> getAll(String starttime,String endtime);
    @Select("select * from infor where names like '%${names}%';")
    public List<Infor> getname(String names);
    @Insert("insert into infor(id,names,password,email,createtime)values(#{id},#{names},#{password},#{email},#{createtime});")
    public int insertInfor(Infor infor);

}
